﻿<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
    
    protected void Page_Load(object sender, EventArgs e)
    {
        loadReminderCount();
    }

    void loadReminderCount()
    {
        object connStr = ConfigurationSettings.AppSettings["sqlConn"];
        using(SqlConnection conn = new SqlConnection(connStr.ToString()))
        {
            SqlCommand cmd = new SqlCommand("sp_ListReminders", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@count", SqlDbType.Bit).Value = 1;
            conn.Open();
            int r_count = (int)cmd.ExecuteScalar();
            lblReminderCount.Text = "<b>("+ r_count +")</b>";
        }
    }
</script>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta http-equiv=No-cache>

<title>CMS</title>

<link type="text/css" rel="stylesheet" href="css/style.css" />
<script language="javascript" src="includes/menustructure.js"></script>

</head>

<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
	<thead>
		<tr>
			<td class="subbar" height="28">
				<table width="100%" border="0" cellspacing="0" cellpadding="0">
				    <tr>
				        <td width="75%">
				            <span class="blueL"><b>Today: </b><%=DateTime.Now.ToLongDateString() %></span>
				        </td>
				        <td width="25%" align="right">
				            <a class="logout" href="#">Logout</a>
				        </td>
				    </tr>
				</table>
			</td>
		</tr>
		<tr>
			<td><img src="images/spacer.gif" width="20" height="10" /></td>
		</tr>
		<tr>
			<td>
				<table width="100%" border="0" cellspacing="0" cellpadding="0">
					<tr>
						<td width="60"><img src="images/spacer.gif" width="60" height="1" /></td>
						<td><h2 class="blueL"><i>Client Management System</i></h2></td>
						<td align="right"><img src="images/logo.gif" alt="Indochina Research" width="108" height="80" /></td>
						<td width="20"><img src="images/spacer.gif" width="20" height="1" /></td>
					</tr>
				</table>
			</td>
		</tr>
		<tr>
			<td><img src="images/spacer.gif" width="20" height="10" /></td>
		</tr>

		<tr bgcolor="#10147e">
			<td height="28" nowrap>				
				<div class="menu">				
					<ul>
						<li><a href="listProposals.aspx" onMouseOver="dropdownmenu(this, event, menu1,'160px')" onMouseOut="delayhidemenu()">Project Management</a></li>
						<li><a href="listClients.aspx">Clients &amp; Contacts</a></li>
						<li><a href="#">Ops files</a></li>
						<li><a href="listReminders.aspx">Billing Reminder <asp:Literal ID="lblReminderCount" runat="server" /></a></li>
					</ul>					
				</div>				
			</td>			
		</tr>
		<tr>
			<td class="subbar" height="28">				
				<table width="100%" border="0" cellspacing="0" cellpadding="0">
				    <tr>
				        <td width="75%">
				            <span class="pathmap">
					            <a href="default.aspx">CPanel</a> :: Project Management
				            </span>
				        </td>
				        <td width="25%" align="right">
				            <a class="blue" href="saveProposal.aspx">Add New*</a>
				        </td>
				    </tr>
				</table>
			</td>
		</tr>
		<tr>
		    <td>&nbsp;</td>
		</tr>
	</thead>
	
	<tbody>
		<tr>
			<td class="content_admin" height="280" valign="top"><img src="images/spacer.gif" width="20" height="20" /></td>
		</tr>
	</tbody>
	
	<tfoot>
	    <tr>
		    <td>&nbsp;</td>
		</tr>
		<tr>
			<td colspan="4">
				<table width="100%" border="0" cellspacing="0" cellpadding="0">
					<tr>
						<td width="50%" style="background:url(images/footer_l.gif) 0 0 repeat-x">&nbsp;</td>
						<td width="50"><img src="images/footer_c.gif" width="50" height="25" /></td>
						<td width="50%" style="background:url(images/footer_r.gif) 0 0 repeat-x">&nbsp;</td>
					</tr>
					<tr>
						<td align="center" colspan="3" height="24">
							<span class="blueL" style="font-size:7.5pt;"><b>Copyright &copy; 2007 Indochina Research</b></span>
						</td>
					</tr>
				</table>
			</td>
		</tr>
	</tfoot>
</table>
</body>
</html>
